Mark Cronk ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	38

About Me

About Me

Linkedin	https://www.linkedin.com/in/col-r-mark-cronk-35106513

Analytics

1,319

Posts

1,112

Visits

12.7k

Points

Sep 16, 2020

Join Date

Nov 20, 2024

Last Active

Reactions

• Insightful 121

  121
• Vote Up 159

  159
• Awesome 3

  3

• Activity
• Discussions
• Comments1.3K

• Re: Sorting Rows

  Mark Cronk

  12/23/20
  Hi @dark_knight , Smartsheet is treating your numbers as text when it sorts. You'll find several work around posted in the Community. If you can, the easiest solution is to use leading 0s to make you…
  1 ·

• Re: Flag is true when status is not complete and date modified is 5 days old

  Mark Cronk

  05/15/21
  =IF(AND(NOT(staus@row="Complete"), Modified@row<today(-5)), 1, 0) Mark
  1 ·

• Re: Dynamically populate a drop-down list

  Mark Cronk

  01/21/21
  Hi @ndeorah , Neither of those capabilites exist currently. Consider submitting an enhancement request at the link below.
  1 ·

• Re: Remove a dropdown option once selected

  Mark Cronk

  01/11/21
  Hi @Chelsea LeBlanc , Smartsheets doesn't currently have the capability to dynamically change dropdown options. It would be a useful capability. You should suggest it as an enhancement, link below. M…
  1 ·

• Re: IF formula with multiple conditions

  Mark Cronk

  05/24/21
  Hi, Try: =IF(AND(Impact@row = "Low", Likelihood@row = "high"), "medium", IF(AND(Impact@row = "high", Likelihood@row = "Low"), "medium", IF(…
  1 ·

Next